Skip to main content

Create Pivot Widget

Create Pivot: This video contains how can create a Pivot Widget in OPNBI.

tip

Only users with Dashboard privilege have access to this section!

Read 5 minutes tutorial here.

dashboard -icon 1

  1. Click on hamburger icon.

    dashboard -icon 1

  2. Click on (+) icon, from dashboard tab.

  3. The Create Dashboard Dialog box will pop up on screen. Enter Dashboard Name as shown in Figure.

  4. Click on Create After entering Dashboard Name in dialog box.

    dashboard -icon 1

  5. You will see an Empty Dashboard, As shown in figure below:

    dashboard -icon 1

  6. From Right Vertical Menu Select the Pivot Widget icon.

  7. The Edit menu box appears as you click on Pivot chart icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:

    dashboard -icon 1

  8. Enter Following details in chart controls:

  • Name: Product Count Data
  • Type: Table
  • Dataset: Product Details.cds
  1. Drag and drop country in rows and Product Line in Columns.

  2. In value click on Setting Icon on Total and enter Following Details.

  • Name: Total
  • Display Name: Total
  • Type: Sum
  • Column1: extendedPrice
  1. Fill above details in edit box, As Shown in figure;

    dashboard -icon 1

  2. Click on Preview and Save and Exit.

  3. Now, match your Pivot with the below example, it should look like the figure below:

    dashboard -icon 1